This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: Import Access Database ~Umberto Nongeroson 6.Jan.04 06:22 PM a Web browser Domino Designer All ReleasesWindows 2000
It's easy to do with LEI but you can also cheat and use DECS. First create a form that contains the fields you want to import. They don't have to be named the same as the Access fields. Create an OLE DB connection document to the Access database (you must have Access installed, and the database file available, on the server where DECS is running). Create a "Virtual Fields" activity and specify the OLE DB connection as the source. Map all the Notes fields to Access fields. Select the option to "retain all fields". Click "Initialize Keys". This will copy all the data from the Access fields into the corresponding Notes fields, creating a document for each row.
This assumes you have just the one table -- if you have more tables, LEI is better since you can do it by Replication. But you could also script it using the LC LSX.
Refer to the LEI redbook for all this stuff. I've posted a link in the EI Forum.
Return to top
. . RE: Import Access Database (~Bill Frokimari... 6.Jan.04)
Print this page
